# Defining the connection parameters

You can add an Oracle database to Qlik Compose to use as a source.

To add an Oracle source database to Qlik Compose:

1. In the New Data Source window, enter the information as described in the table below.

   Data source fields

   | Field | Description |
   | --- | --- |
   | Type | Select Oracle. |
   | Server Name | Specify the name or IP address of the Oracle server machine.<br><br>OR<br><br>Specify the TNS name. |
   | Port | If you specified a TNS name in the Server Name field, make sure that this field is empty. Optionally, change the default port. |
   | User Name | Specify your user name for accessing the Oracle database.<br><br>The specified user must have read/write privileges on the Oracle database. |
   | Password | Specify your password for accessing the Oracle database. |
   | SID | If you specified a TNS name in the Server Name field, make sure that this field is empty. Otherwise, specify the Oracle SID. |
   | Schema | Specify the schema containing the source tables. |

2. Click Test Connection to verify that Compose is able to establish a connection with the specified database.

3. Click OK to save your settings.

   The database is added to the list on the left side of the Manage Databases window.